HEALTH DATA ANALYSIS

Public Health Data Analysis: The HIV Project

Part One: Descriptive Epidemiology

The data set selected for analysis is that of HIV. It presents the prevalence of HIV/AIDS among 359 cases by among other things, gender, ethnicity, city of residence, state, age, and sexual orientation.

Place: the highest occurrence of HIV/AIDS is reported in the City of Atlanta, which accounts for 47.5 percent of HIV/AIDS cases among the 359 cases. The second-highest occurrence is reported in College Park at 8.93 percent, followed by Alpharetta at 7.27 percent. The lowest HIV/AIDS occurrence is reported in Hapeville and Johns Creek, both of which report a prevalence rate less than 2 percent. Fig 1 below presents the frequency table showing the frequency of viral load by city of residence. The visual representation of viral load by city is presented in the pie chart labeled as Chart 1.

Fig 2: Viral Load by City of Residence

Current form: C:UsersSusanEpi Info 7ProjectsHIVHIV.prj:Case

Record count: 359 (Deleted records excluded) Date: 19/06/2022 21:48

Frequency

Frequency variable: City

Weight variable: ViralLoad

Include missing: False

City

Frequency

Percent

Cum. Percent

Wilson 95% LCL

Wilson 95% UCL

Alpharetta

120542

7.27%

7.27%

7.23%

7.31%

Atlanta

781961.9

47.16%

54.43%

47.08%

47.23%

Chattahoochee Hills

62698.54

3.78%

58.21%

3.75%

3.81%

College Park

148125.2

8.93%

67.14%

8.89%

8.98%

East...

These findings are summarized in frequency table 2 below. Figure 3 summarizes the person characteristics of the dataset by ethnic grouping. African Americans report a higher viral load frequency as compared to Asians and Alaskan Natives. This is despite the fact that whites form the biggest percentage of the sample as shown in the combined frequency table in figure 4.

Figure : Frequency Table of Viral Load against Gender

Frequency

Frequency variable: Sex

Weight variable: ViralLoad

Include missing: False

Sex

Frequency

Percent

Cum. Percent

Wilson 95%...

…